--
-- PostgreSQL database dump
--

-- Started on 2008-08-15 13:53:57

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1524 (class 1259 OID 64147)
-- Dependencies: 3
-- Name: j_company; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE j_company (
    j_company_id integer NOT NULL,
    code text,
    topic text,
    accessionno character(25) NOT NULL
);


ALTER TABLE public.j_company OWNER TO postgres;

--
-- TOC entry 1523 (class 1259 OID 64145)
-- Dependencies: 3 1524
-- Name: j_company_j_company_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE j_company_j_company_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.j_company_j_company_id_seq OWNER TO postgres;

--
-- TOC entry 1816 (class 0 OID 0)
-- Dependencies: 1523
-- Name: j_company_j_company_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE j_company_j_company_id_seq OWNED BY j_company.j_company_id;


--
-- TOC entry 1817 (class 0 OID 0)
-- Dependencies: 1523
-- Name: j_company_j_company_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('j_company_j_company_id_seq', 198, true);


--
-- TOC entry 1809 (class 2604 OID 64150)
-- Dependencies: 1524 1523 1524
-- Name: j_company_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE j_company ALTER COLUMN j_company_id SET DEFAULT nextval('j_company_j_company_id_seq'::regclass);


--
-- TOC entry 1813 (class 0 OID 64147)
-- Dependencies: 1524
-- Data for Name: j_company; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY j_company (j_company_id, code, topic, accessionno) FROM stdin;
1	ccred	Citigroup Inc	YOSHIN0020080117e41h000gt
2	matsu	Matsushita Electric Industrial Co., Ltd	YOSHIN0020080213e42d000fh
3	epd	Electric Power Development Co Ltd	YOSHIN0020080224e42o0009c
4	exim	Japan Bank for International Cooperation	YOSHIN0020080319e43j000ie
5	exim	Japan Bank for International Cooperation	YOSHIN0020080320e43k000c3
6	tkyelc	The Tokyo Electric Power Co Inc	YOSHIN0020080324e43o000bu
7	iwshot	IWANAMI SHOTEN KK	YOSHIN0020080329e43t000ic
8	fujya	Fujiya Co Ltd	YOSHIN0020070114e31e000c7
9	sapbr	Sapporo Holdings Ltd	YOSHIN0020070217e32h000fq
10	daimru	The Daimaru Inc	YOSHIN0020070218e32i0009b
11	mszhld	Matsuzakaya Holdings Co., Ltd.	YOSHIN0020070218e32i0009b
12	yamha	Yamaha Motor Co Ltd	YOSHIN0020070226e32q000bb
13	nipgak	Yamaha Corp	YOSHIN0020070226e32q000bb
14	ccred	Citigroup Inc	YOSHIN0020070308e338000f7
15	ccred	Citigroup Inc	YOSHIN0020070313e33d000g4
16	niksec	Nikko Cordial Corp	YOSHIN0020070313e33d000g4
17	npndns	Denso Corp	YOSHIN0020070320e33k000fj
18	sapbr	Sapporo Holdings Ltd	YOSHIN0020070402e33u0008a
19	niksec	Nikko Cordial Corp	YOSHIN0020070428e34s000fc
20	ccred	Citigroup Inc	YOSHIN0020070428e34s000fc
21	mtsui	Mitsui & Co Ltd	YOSHIN0020070502e352000bt
22	kyelp	Kyushu Electric Power Co Inc	YOSHIN0020070502e352000bt
23	pntxuk	Pentax Corp	YOSHIN0020070522e35m000gg
24	sbmp	Snow Brand Milk Products Co Ltd	YOSHIN0020070626e36q000gy
25	chbelp	Chubu Electric Power Co Inc	YOSHIN0020070630e36u000fs
26	rakinc	Rakuten Inc	YOSHIN0020070630e36u000fs
27	tokbs	Tokyo Broadcasting System Inc	YOSHIN0020070630e36u000fs
28	lionth	livedoor Co Ltd	YOSHIN0020070720e37k000dj
29	isetn	Isetan Co Ltd	YOSHIN0020070727e37r000e0
30	misuko	Mitsukoshi Ltd	YOSHIN0020070727e37r000e0
31	tkyelc	The Tokyo Electric Power Co Inc	YOSHIN0020070822e38m000ey
32	shwdnk	Showa Denko KK	YOSHIN0020070825e38p000hs
33	tkystl	Tokyo Steel Manufacturing Co Ltd	YOSHIN0020070825e38p000hs
34	sanyoe	SANYO Electric Co., Ltd	YOSHIN0020070923e39n000ax
35	hokel	Hokuriku Electric Power Co	YOSHIN0020071027e3ar000fm
36	chbelp	Chubu Electric Power Co Inc	YOSHIN0020071027e3ar000fm
37	novaco	Nova Corp	YOSHIN0020071028e3as0009a
38	novaco	Nova Corp	YOSHIN0020071112e3bb000ag
39	gnelc	General Electric Company	YOSHIN0020071116e3bg000et
40	kyelp	Kyushu Electric Power Co Inc	YOSHIN0020060112e21b000i1
41	lionth	livedoor Co Ltd	YOSHIN0020060118e21h000g1
42	vaclja	livedoor MARKETING Co., Ltd.	YOSHIN0020060118e21h000g1
43	lionth	livedoor Co Ltd	YOSHIN0020060120e21j000fk
44	tokse	Tokyo Stock Exchange Inc	YOSHIN0020060120e21j000fk
45	lionth	livedoor Co Ltd	YOSHIN0020060125e21o000h4
46	lionth	livedoor Co Ltd	YOSHIN0020060127e21r000fi
47	lionth	livedoor Co Ltd	YOSHIN0020060131e21v000gs
48	yamha	Yamaha Motor Co Ltd	YOSHIN0020060208e228000gu
49	kyelp	Kyushu Electric Power Co Inc	YOSHIN0020060215e22f000gu
50	yamha	Yamaha Motor Co Ltd	YOSHIN0020060217e22h000en
51	lionth	livedoor Co Ltd	YOSHIN0020060223e22n000gd
52	lionth	livedoor Co Ltd	YOSHIN0020060225e22p000eu
53	japasy	Japan Airlines Corporation	YOSHIN0020060227e22r000ax
54	lionth	livedoor Co Ltd	YOSHIN0020060301e231000fy
55	lionth	livedoor Co Ltd	YOSHIN0020060303e233000gf
56	fuju	Fujitsu Ltd	YOSHIN0020060307e237000hl
57	lionth	livedoor Co Ltd	YOSHIN0020060312e23c000cn
58	lionth	livedoor Co Ltd	YOSHIN0020060314e23e000g3
59	sanyoe	Sanyo Electric Co Ltd	YOSHIN0020060316e23g000g2
60	tais	Taisei Corp	YOSHIN0020060317e23h000ey
61	hokel	Hokuriku Electric Power Co	YOSHIN0020060325e23p000hc
62	japasy	Japan Airlines Corporation	YOSHIN0020060326e23q0009m
63	kyelp	Kyushu Electric Power Co Inc	YOSHIN0020060328e23s000oi
64	aifulc	Aiful Corp	YOSHIN0020060415e24f000g1
65	ebco	Ebara Corp	YOSHIN0020060419e24j000gk
66	htzosn	Hitachi Zosen Corp	YOSHIN0020060419e24j000gk
67	wstral	West Japan Railway Co	YOSHIN0020060424e24o000nj
68	jarail	Japan Railways Group	YOSHIN0020060424e24o000nj
69	ntt	Nippon Telegraph and Telephone Corp	YOSHIN0020060504e2540007v
70	lionth	livedoor Co Ltd	YOSHIN0020060510e259000g8
71	matsu	Matsushita Electric Industrial Co Ltd	YOSHIN0020060517e25h000fz
72	nisan	Nissan Motor Co Ltd	YOSHIN0020060517e25h000fz
73	htchi	Hitachi Ltd	YOSHIN0020060517e25h000fz
74	ntt	Nippon Telegraph and Telephone Corp	YOSHIN0020060522e25m000da
75	mitfin	Mitsubishi UFJ Financial Group, Inc.	YOSHIN0020060524e25o000gp
76	lionth	livedoor Co Ltd	YOSHIN0020060527e25r000gg
77	hancor	Hankyu Holdings, Inc.	YOSHIN0020060530e25u000g8
78	hanel	Hanshin Electric Railway Co Ltd	YOSHIN0020060530e25u000g8
79	lionth	livedoor Co Ltd	YOSHIN0020060603e263000gu
80	lionth	livedoor Co Ltd	YOSHIN0020060606e266000p6
81	fuju	Fujitsu Ltd	YOSHIN0020060616e26g000fq
82	tmfin	Mitsui Sumitomo Insurance Co	YOSHIN0020060623e26n000ex
83	lionth	livedoor Co Ltd	YOSHIN0020060624e26o000ge
84	kobest	Kobe Steel Ltd	YOSHIN0020060628e26s000g4
85	nipstl	Nippon Steel Corp	YOSHIN0020060628e26s000g4
86	smtomi	Sumitomo Metal Industries Ltd	YOSHIN0020060628e26s000g4
87	gnmoc	General Motors Corp	YOSHIN0020060716e27g0008k
88	nisan	Nissan Motor Co Ltd	YOSHIN0020060716e27g0008k
89	suzuk	Suzuki Motor Corp	YOSHIN0020060716e27g0008k
90	chbelp	Chubu Electric Power Co Inc	YOSHIN0020060818e28i000eo
91	lionth	livedoor Co Ltd	YOSHIN0020060905e295000g2
92	mtsubc	Mitsubishi Corp	YOSHIN0020060908e298000eh
93	mtsui	Mitsui & Co Ltd	YOSHIN0020060908e298000eh
94	jtspc	Japan Tobacco Inc	YOSHIN0020060908e298000eh
95	nisan	Nissan Motor Co Ltd	YOSHIN0020060908e298000eh
96	sftbnk	Softbank Corp	YOSHIN0020061031e2av000gu
97	matsu	Matsushita Electric Industrial Co Ltd	YOSHIN0020061124e2bo000bx
98	htchi	Hitachi Ltd	YOSHIN0020061124e2bo000bx
99	nisan	Nissan Motor Co Ltd	YOSHIN0020061124e2bo000bx
100	nttmcn	NTT DoCoMo Inc	YOSHIN0020061213e2cd000gl
101	ntt	Nippon Telegraph and Telephone Corp	YOSHIN0020061213e2cd000gl
102	kanelp	The Kansai Electric Power Co Inc	YOSHIN0020061230e2cu0006e
103	kyelp	Kyushu Electric Power Co Inc	YOSHIN0020061230e2cu0006e
104	mitmot	Mitsubishi Motors Corp	YOSHIN0020050131e11t001cr
105	mitsu	Mitsubishi Heavy Industries Ltd	YOSHIN0020050131e11t001cr
106	nisan	Nissan Motor Co Ltd	YOSHIN0020050131e11t001cr
107	chbelp	Chubu Electric Power Co Inc	YOSHIN0020050211e1290019u
108	fujsan	FUJISANKEI COMMUNICATIONS	YOSHIN0020050211e12a00271
109	nippob	Nippon Broadcasting System Inc	YOSHIN0020050211e12a00271
110	fujsan	FUJISANKEI COMMUNICATIONS	YOSHIN0020050228e12p000g7
111	nippob	Nippon Broadcasting System Inc	YOSHIN0020050228e12p000g7
112	dai	The Daiei Inc	YOSHIN0020050304e133000he
113	mrubni	Marubeni Corp	YOSHIN0020050304e133000he
114	kokudc	Kokudo Corporation	YOSHIN0020050307e134000hb
115	lionth	livedoor Co Ltd	YOSHIN0020050314e13c001a0
116	lionth	livedoor Co Ltd	YOSHIN0020050325e13o000h5
117	kokudc	Kokudo Corporation	YOSHIN0020050328e13r00257
118	tkyelc	The Tokyo Electric Power Co Inc	YOSHIN0020050401e13v000iq
119	kanelp	The Kansai Electric Power Co Inc	YOSHIN0020050401e13v000iq
120	matsu	Matsushita Electric Industrial Co Ltd	YOSHIN0020050404e141000jh
121	nisan	Nissan Motor Co Ltd	YOSHIN0020050404e141000jh
122	lionth	livedoor Co Ltd	YOSHIN0020050420e14j000gw
123	wstral	West Japan Railway Co	YOSHIN0020050427e14q000ig
124	jarail	Japan Railways Group	YOSHIN0020050427e14q000ig
125	wstral	West Japan Railway Co	YOSHIN0020050509e1570014o
126	jarail	Japan Railways Group	YOSHIN0020050509e1570014o
127	unol	Unocal Corp	YOSHIN0020050808e187001xj
128	fhi	Fuji Heavy Industries Ltd	YOSHIN0020051010e1a70015z
129	gnmoc	General Motors Corp	YOSHIN0020051010e1a70015z
130	toyta	Toyota Motor Corp	YOSHIN0020051010e1a70015z
131	rakinc	Rakuten Inc	YOSHIN0020051017e1af001ae
132	tokbs	Tokyo Broadcasting System Inc	YOSHIN0020051017e1af001ae
133	nipstl	Nippon Steel Corp	YOSHIN0020051109e1b8000gu
134	rakinc	Rakuten Inc	YOSHIN0020051205e1c2000gv
135	tokbs	Tokyo Broadcasting System Inc	YOSHIN0020051205e1c2000gv
136	exim	Japan Bank for International Cooperation	YOSHIN0020051219e1ci00210
137	nmsc	Nomura Securities Co Ltd	YOSHIN0020051223e1cm000h3
138	nomsec	Nomura Holdings Inc	YOSHIN0020051223e1cm000h3
139	wstral	West Japan Railway Co	YOSHIN0020051226e1co0010g
140	jarail	Japan Railways Group	YOSHIN0020051226e1co0010g
141	wstral	West Japan Railway Co	YOSHIN0020051228e1cr000d9
142	jarail	Japan Railways Group	YOSHIN0020051228e1cr000d9
143	rwood	Ripplewood Holdings LLC	YOSHIN0020040220e02k000i6
144	mitmot	Mitsubishi Motors Corp	YOSHIN0020040312e03c000j1
145	nisan	Nissan Motor Co Ltd	YOSHIN0020040321e03l000b2
146	toyta	Toyota Motor Corp	YOSHIN0020040321e03l000b2
147	mitmot	Mitsubishi Motors Corp	YOSHIN0020040507e057000jc
148	mftbc	Mitsubishi Fuso Truck & Bus Corp	YOSHIN0020040507e057000jc
149	damb	DaimlerChrysler AG	YOSHIN0020040507e057000jc
150	nisan	Nissan Motor Co Ltd	YOSHIN0020040513e05d000n0
151	hond	Honda Motor Co Ltd	YOSHIN0020040513e05d000n0
152	toyta	Toyota Motor Corp	YOSHIN0020040513e05d000n0
153	jtspc	Japan Tobacco Inc	YOSHIN0020040603e063000mb
154	mitmot	Mitsubishi Motors Corp	YOSHIN0020040604e064000oj
155	niksec	Nikko Cordial Corp	YOSHIN0020040630e06u000k3
156	toyta	Toyota Motor Corp	YOSHIN0020040630e06u000k3
157	ufjhol	UFJ Holdings Inc	YOSHIN0020040716e07f000fw
158	kanelp	The Kansai Electric Power Co Inc	YOSHIN0020040817e08g000al
159	kanelp	The Kansai Electric Power Co Inc	YOSHIN0020040906e093000gr
160	mtshol	Mitsui Trust Holdings Inc	YOSHIN0020041126e0bp000gi
161	kanbk	The Kanto Tsukuba Bank Ltd	YOSHIN0020041129e0bs0022g
162	kiybnk	Kiyo Bank Ltd	YOSHIN0020041129e0bs0022g
163	fuju	Fujitsu Ltd	YOSHIN0020041220e0cj0022i
164	htchi	Hitachi Ltd	YOSHIN0020041220e0cj0022i
165	toyta	Toyota Motor Corp	YOSHIN0020041220e0cj0022i
166	mitmot	Mitsubishi Motors Corp	YOSHIN0020041227e0co000bf
167	dai	The Daiei Inc	YOSHIN0020041231e0cu0006z
168	snyco	Sony Corp	YOSHIN0020030630dz6t000fx
169	ohki	Ohki Co Ltd	YOSHIN0020030707dz7700111
170	toyta	Toyota Motor Corp	YOSHIN0020030731dz7v000j0
171	mitmot	Mitsubishi Motors Corp	YOSHIN0020031125dzbo0011k
172	snyco	Sony Corp	YOSHIN0020031125dzbo0011k
173	FUJU	FUJITSU LTD (JAP)	yoshin0020030225dz2p002b5
174	HOND	HONDA MOTOR COMPANY LTD (JAP)	yoshin0020030313dz3d002qt
175	HTCHI	HITACHI LTD (JAP)	yoshin0020030313dz3d002qt
176	MITMOT	MITSUBISHI MOTORS CORP (JAP)	yoshin0020030313dz3d002qt
177	CHBELP	CHUBU ELECTRIC POWER CO INC (JAP)	yoshin0020030315dz3f000et
178	TOYTA	TOYOTA MOTOR CORP (JAP)	yoshin0020030403dz42004ck
179	DAIHOL		yoshin0020030519dz5i003kk
180	DAIHOL		yoshin0020030519dz5j0043i
181	MIZBNK	MIZUHO HOLDINGS INC (JAP)	yoshin0020020503dy4700fs9
182	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020524dy5n005aw
183	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020524dy5o005ow
184	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020525dy5p000pd
185	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020527dy5q003pb
186	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020528dy5r005pv
187	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020528dy5s0064y
188	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020530dy5u005b8
189	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020531dy5v0023x
190	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020601dy610016c
191	YOMSHM	YOMIURI SHIMBUN (JAP)	yoshin0020020603dy620060x
192	SNOBF	SNOW BRAND FOOD CO (JAP)	yoshin0020020606dy6600568
193	TOYTA	TOYOTA MOTOR CORP (JAP)	yoshin0020020814dy8e00533
194	NMEAT	NIPPON MEAT PACKERS INC (JAP)	yoshin0020020817dy8g000mt
195	SNOBF	SNOW BRAND FOOD CO (JAP)	yoshin0020020817dy8g000mt
196	NMEAT	NIPPON MEAT PACKERS INC (JAP)	yoshin0020020821dy8l005yz
197	SNOBF	SNOW BRAND FOOD CO (JAP)	yoshin0020020821dy8l005yz
198	TDA	JAPAN AIR SYSTEM CO (JAP)	yoshin0020020927dy9r003t2
\.


--
-- TOC entry 1811 (class 2606 OID 64155)
-- Dependencies: 1524 1524
-- Name: j_company_pk; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY j_company
    ADD CONSTRAINT j_company_pk PRIMARY KEY (j_company_id);


--
-- TOC entry 1812 (class 2606 OID 64156)
-- Dependencies: 1520 1524
-- Name: j_company_accessionno_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY j_company
    ADD CONSTRAINT j_company_accessionno_fk FOREIGN KEY (accessionno) REFERENCES j_editorial(accessionno);


-- Completed on 2008-08-15 13:53:58

--
-- PostgreSQL database dump complete
--

